GradientStyle Property

Returns the gradient style for the specified fill. Read-only MsoGradientStyle.

MsoGradientStyle can be one of these MsoGradientStyle constants.

msoGradientDiagonalDown

msoGradientDiagonalUp

msoGradientFromCenter

msoGradientFromCorner

msoGradientFromTitle

msoGradientHorizontal

msoGradientMixed

msoGradientVertical

This property is read-only. Use the OneColorGradient or TwoColorGradient method to set the gradient style for the fill.

expression.GradientStyle

expression Required. An expression that returns one of the objects in the Applies To list.

Example

This example sets the chart's fill format so that its gradient style is changed to msoGradientDiagonalUp if it was originally msoGradientDiagonalDown.

With myChart.ChartArea.Fill
   If .Type = msoFillGradient Then
      If .GradientColorType = msoGradientOneColor Then
         If .GradientStyle = msoGradientDiagonalDown Then
            .OneColorGradient msoGradientDiagonalUp, _
                .GradientVariant, .GradientDegree
         End If
      End If
   End If
End With